██    ██ ██    ██  ██████  ██  ██████  ██    ██ ███████ ██████  ██    ██ 
     ██  ██  ██    ██ ██       ██ ██    ██ ██    ██ ██      ██   ██  ██  ██  
      ████   ██    ██ ██   ███ ██ ██    ██ ██    ██ █████   ██████    ████   
       ██    ██    ██ ██    ██ ██ ██ ▄▄ ██ ██    ██ ██      ██   ██    ██    
       ██     ██████   ██████  ██  ██████   ██████  ███████ ██   ██    ██    
                                      ▀▀
Sets - Execution started 31/01/2023 22:53 UTC
By Guilherme Ruiz

Table of Contents¶

  • 1  Data aquisition
    • 1.1  Fetch set lists
    • 1.2  Fetch set properties
    • 1.3  Merge data
    • 1.4  Save data
  • 3  Check changes
    • 3.1  Load previous data
    • 3.2  Generate changelog
  • 4  Data visualization
    • 4.1  Full data
    • 4.2  Set
    • 4.3  Card number
    • 4.4  Name
    • 4.5  Rarity
      • 4.5.1  By unique
      • 4.5.2  By combination
    • 4.6  Print
    • 4.7  Quantity
    • 4.8  Region
    • 4.9  Cover card
    • 4.10  Series
    • 4.11  Set type
    • 4.12  Release
      • 4.12.1  By year
      • 4.12.2  By month
      • 4.12.3  By day
      • 4.12.4  By region
      • 4.12.5  By series
      • 4.12.6  By set type
  • 5  Debug
    • 5.1  Has nan name/number
    • 5.2  Has nan rarity
    • 5.3  Has quantity as print
    • 5.4  Has nan release
    • 5.5  Has print as rarity
    • 5.6  Merge failed
  • 6  Epilogue
    • 6.1  HTML export

Data aquisition¶

Fetch set lists¶

  0%|          | 0/80 [00:00<?, ?it/s]
4120 set lists received - 76 errors

Fetch set properties¶

  0%|          | 0/96 [00:00<?, ?it/s]
1430 set properties received - 3 errors

Merge data¶

Set properties merged

Save data¶

Data saved

Check changes¶

Load previous data¶

File loaded

Generate changelog¶

Rarity Version
Card number
20CP-JPC01 (20th Secret rare,) New
20CP-JPC01 (20th Secret Rare,) Old
20CP-JPC02 (20th Secret rare,) New
20CP-JPC02 (20th Secret Rare,) Old
ABPF-DESE1 (Super Rare,) Old
... ... ...
ZDC1-FR002 (Ultra Rare,) Old
ZDC1-FR003 (Ultra rare,) New
ZDC1-FR003 (Ultra Rare,) Old
<NA> (Millennium Rare,) Old
<NA> (Millennium rare,) New

4094 rows × 2 columns

Changelog saved

Data visualization¶

Full data¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
0 Abyss Rising ABYR-FR000 Ignoble Knight of Black Laundsallyn (Super Rare,) <NA> <NA> FR 2012-11-08 Core Booster Booster pack (Number C32: Shark Drake Veiss,) https://yugipedia.com/wiki/Abyss_Rising 2022-07-23 10:29:14 both
1 Abyss Rising ABYR-FR001 Gagaga Caesar (Rare,) <NA> <NA> FR 2012-11-08 Core Booster Booster pack (Number C32: Shark Drake Veiss,) https://yugipedia.com/wiki/Abyss_Rising 2022-07-23 10:29:14 both
2 Abyss Rising ABYR-FR002 Bull Blader (Common,) <NA> <NA> FR 2012-11-08 Core Booster Booster pack (Number C32: Shark Drake Veiss,) https://yugipedia.com/wiki/Abyss_Rising 2022-07-23 10:29:14 both
3 Abyss Rising ABYR-FR003 Achacha Chanbara (Common,) <NA> <NA> FR 2012-11-08 Core Booster Booster pack (Number C32: Shark Drake Veiss,) https://yugipedia.com/wiki/Abyss_Rising 2022-07-23 10:29:14 both
4 Abyss Rising ABYR-FR004 Mogmole (Common,) <NA> <NA> FR 2012-11-08 Core Booster Booster pack (Number C32: Shark Drake Veiss,) https://yugipedia.com/wiki/Abyss_Rising 2022-07-23 10:29:14 both
... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
156159 Jump Festa 2004 promotional cards PC3-007 Bazoo the Soul-Eater (Common, Normal Parallel Rare) <NA> <NA> JP 2003-12-20 <NA> Tournament prize card NaN https://yugipedia.com/wiki/Jump_Festa_2004_pro... 2022-11-06 04:44:51 both
156160 Jump Festa 2005 promotional cards PC5-JP007 Dark Balter the Terrible (Common, Normal Parallel Rare) <NA> <NA> JP 2004-12-18 <NA> Promotional card NaN https://yugipedia.com/wiki/Jump_Festa_2005_pro... 2022-11-06 05:15:26 both
156161 Jump Festa 2005 promotional cards PC5-JP008 Ryu Senshi (Common, Normal Parallel Rare) <NA> <NA> JP 2004-12-18 <NA> Promotional card NaN https://yugipedia.com/wiki/Jump_Festa_2005_pro... 2022-11-06 05:15:26 both
156162 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Academia_Disk 2022-12-28 20:46:20 right_only
156163 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Structure_Deck:_Mar... 2014-07-03 18:52:14 right_only

156164 rows × 14 columns

Full data available here

Set¶

Total number of sets: 1435
Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Set
"Amabie-San" Present Campaign 2 1 1 0 0 1 1 0 1 0 1 1 1
"Blue-Eyes White Dragon Rush Rare Special Red Version" GET Campaign 2 1 1 0 0 2 2 0 1 0 1 1 1
"Blue-Eyes White Dragon Secret Rare Special Blue Version" GET Campaign 1 1 1 0 0 1 1 0 1 0 1 1 1
"Blue-Eyes White Dragon" 20th Anniversary Gold Edition 0 1 1 0 0 1 1 0 1 0 1 1 1
"Blue-Eyes White Dragon" 20th Anniversary Silver Edition 0 1 1 0 0 1 1 0 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Yu-Gi-Oh! ZEXAL World Duel Carnival Duel Champion Guide! promotional card 1 1 1 0 0 1 1 0 1 0 1 1 1
Yu-Gi-Oh! ZEXAL World Duel Carnival promotional cards 18 3 2 0 0 6 2 0 1 0 1 1 1
Yugi's Legendary Decks 650 112 3 0 0 5 2 0 1 0 1 1 1
Zexal Collection Tin 120 24 3 0 0 5 1 0 1 1 1 1 1
Zombie World Structure Deck 185 37 2 0 2 5 1 0 1 1 1 1 1

1435 rows × 13 columns

Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
count 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.000000 1435.0
mean 107.213240 27.549129 2.505226 0.357491 0.096864 2.696864 1.455052 0.390941 0.953310 0.310801 0.994425 0.994425 1.0
std 236.084401 45.357431 2.301038 0.818887 0.446227 2.298980 0.997155 0.488131 0.211047 0.462983 0.074483 0.074483 0.0
min 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 1.0
25% 1.000000 1.000000 1.000000 0.000000 0.000000 1.000000 1.000000 0.000000 1.000000 0.000000 1.000000 1.000000 1.0
50% 10.000000 5.000000 2.000000 0.000000 0.000000 1.000000 1.000000 0.000000 1.000000 0.000000 1.000000 1.000000 1.0
75% 86.000000 41.000000 3.000000 0.000000 0.000000 5.000000 2.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.0
max 1652.000000 307.000000 17.000000 6.000000 3.000000 10.000000 9.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.0

Card number¶

Total number of card numbers: 151985
Set Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Card number
15AX-JP000 2 1 1 1 0 1 1 0 1 0 2 2 1
15AX-JPM01 1 1 1 1 0 1 1 0 1 0 1 1 1
15AX-JPM02 1 1 1 1 0 1 1 0 1 0 1 1 1
15AX-JPM03 1 1 1 1 0 1 1 0 1 0 1 1 1
15AX-JPM04 1 1 1 1 0 1 1 0 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
ZTIN-SP021 1 1 1 0 0 1 1 0 1 1 1 1 1
ZTIN-SPV01 1 1 1 0 0 1 1 0 1 1 1 1 1
ZTIN-SPV02 1 1 1 0 0 1 1 0 1 1 1 1 1
ZTIN-SPV03 1 1 1 0 0 1 1 0 1 1 1 1 1
<NA> 44 406 7 2 2 10 40 6 11 6 43 43 3

151986 rows × 13 columns

Name¶

Total number of card names: 12579
Set Card number Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Name
"A Legendary Ocean" 1 1 0 0 0 1 1 0 1 1 1 1 1
"A" Cell Breeding Device 4 9 1 1 0 7 6 1 2 3 4 4 1
"A" Cell Incubator 2 8 1 2 0 7 6 1 1 2 2 2 1
"A" Cell Recombination Device 1 8 1 0 0 8 4 1 1 1 1 1 1
"A" Cell Scatter Burst 3 9 1 1 0 7 6 1 1 3 3 3 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Zubaba Knight 12 50 5 1 1 8 23 2 2 7 12 12 1
Zubababancho Gagagacoat 1 2 1 1 0 2 2 1 1 1 1 1 1
Zure, Knight of Dark World 8 24 1 1 1 10 14 1 4 4 8 8 1
Zushin the Sleeping Giant 3 14 3 1 0 8 4 1 2 3 3 3 1
<NA> 9 173 3 0 0 9 12 4 4 4 9 9 2

12580 rows × 13 columns

Set Card number Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
count 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000 12579.000000
mean 3.142778 12.069958 2.097067 0.682487 0.107481 6.891724 5.983385 1.090627 1.473329 1.843469 3.131489 3.131489 1.010812
std 3.515854 11.605704 1.536912 0.676706 0.336553 2.558872 5.904548 0.788325 0.936945 1.841657 3.495227 3.495227 0.103420
min 1.000000 0.000000 0.000000 0.000000 0.000000 1.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 1.000000
25% 1.000000 7.000000 1.000000 0.000000 0.000000 6.000000 3.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000
50% 2.000000 9.000000 2.000000 1.000000 0.000000 8.000000 4.000000 1.000000 1.000000 1.000000 2.000000 2.000000 1.000000
75% 4.000000 14.000000 3.000000 1.000000 0.000000 8.000000 7.000000 1.000000 2.000000 2.000000 4.000000 4.000000 1.000000
max 80.000000 275.000000 30.000000 4.000000 3.000000 15.000000 122.000000 12.000000 16.000000 41.000000 80.000000 80.000000 2.000000

Rarity¶

Total number of rarities: 61

By unique¶

Set Card number Name Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Rarity
10000 Secret Rare 2 7 1 1 0 7 2 1 1 2 2 2 1
20th Secret Rare 15 133 132 3 0 1 12 3 3 6 15 15 1
20th Secret rare 1 2 2 0 0 1 1 0 1 0 1 1 1
Collector"s Rare 5 211 61 2 0 7 5 2 1 5 5 5 1
Collector's Rare 1 90 15 2 0 6 1 0 1 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Ultra Rare 773 17897 3163 7 2 16 1041 32 26 277 771 771 2
Ultra Secret Rare 3 0 8 0 0 1 3 1 3 0 3 3 1
Ultra rare 51 134 77 0 0 8 69 4 8 2 51 51 1
c 1 330 55 0 0 6 2 0 1 1 1 1 1
NaN 15 376 206 0 0 4 12 3 2 3 14 14 3

62 rows × 13 columns

By combination¶

Set Card number Name Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Rarity
(10000 Secret Rare,) 2 7 1 1 0 7 2 1 1 2 2 2 1
(20th Secret Rare,) 8 23 22 1 0 1 7 2 3 1 8 8 1
(20th Secret rare,) 1 2 2 0 0 1 1 0 1 0 1 1 1
(Common,) 522 70072 7920 5 3 16 854 24 22 244 520 520 2
(Common, Duel Terminal Normal Parallel Rare) 1 834 139 2 0 6 1 0 1 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
(Ultra Rare, Ultra Parallel Rare, Ultimate Rare) 5 5 5 0 0 1 3 2 1 3 5 5 1
(Ultra Secret Rare,) 3 0 8 0 0 1 3 1 3 0 3 3 1
(Ultra rare,) 51 134 77 0 0 8 69 4 8 2 51 51 1
(c,) 1 330 55 0 0 6 2 0 1 1 1 1 1
NaN 15 376 206 0 0 4 12 3 2 3 14 14 3

138 rows × 13 columns

Print¶

Total number of prints: 16
Set Card number Name Rarity Quantity Region Release Series Set type Cover card Page URL Modification date _merge
Print
American debut 1 3 3 1 0 1 1 0 1 1 1 1 1
European & Oceanian debut 1 6 6 1 0 1 1 0 1 0 1 1 1
European debut 12 146 146 5 0 2 10 0 2 1 12 12 1
Functional errata 1 2 2 1 0 1 1 0 1 1 1 1 1
New 233 11760 3987 52 3 11 250 19 13 129 231 231 2
New art 1 4 2 1 0 2 2 0 1 1 1 1 1
New artwork 10 74 15 5 0 7 12 3 4 4 10 10 1
New artwork (renamed) 1 3 3 1 0 1 1 0 1 0 1 1 1
North American debut 2 4 4 2 0 2 2 0 2 0 2 2 1
Oceanian debut 1 1 1 1 0 1 1 0 1 0 1 1 1
Reprint 229 14033 4316 51 3 11 246 18 12 127 227 227 2
Reprint (New Art) 2 2 1 2 0 2 2 1 1 1 2 2 1
Reprint (functional errata) 15 33 21 10 0 8 14 3 3 5 15 15 1
Reprint (new artwork) 1 1 1 1 0 1 1 0 1 1 1 1 1
Reprint (renamed) 2 76 76 6 0 1 2 1 1 0 2 2 1
TCG legal debut 1 1 1 1 0 1 1 1 1 1 1 1 1
<NA> 1349 126013 11419 122 3 16 1447 42 37 315 1341 1341 3

Quantity¶

Total number of quantities: 3
Set Card number Name Rarity Print Region Release Series Set type Cover card Page URL Modification date _merge
Quantity
1 66 8760 1167 10 2 11 108 1 5 45 65 65 2
2 65 839 165 4 2 11 108 1 5 44 64 64 2
3 8 64 20 1 2 8 11 0 3 6 8 8 1
<NA> 1372 142334 12503 136 16 16 1502 45 36 316 1364 1364 3

Region¶

Total number of regions: 16
Set Card number Name Rarity Print Quantity Release Series Set type Cover card Page URL Modification date _merge
Region
AE 34 1527 1493 12 0 2 31 2 7 19 34 34 1
AU 2 100 87 3 0 0 1 0 1 2 2 2 1
DE 455 20372 10393 54 4 3 381 12 18 219 454 454 2
EN 658 20184 10480 61 14 3 536 22 23 207 657 657 2
EU 25 543 456 9 3 0 16 2 9 6 25 25 1
FC 3 102 87 3 0 0 1 0 2 2 3 3 1
FR 448 19776 10380 56 4 3 375 14 18 219 447 447 2
IT 447 20051 10388 55 4 3 378 12 18 218 446 446 2
JA 3 185 185 8 0 0 3 2 2 3 3 3 1
JP 714 19087 11213 94 6 3 530 28 28 247 709 709 2
KR 383 15937 10755 60 4 3 333 16 15 224 378 378 2
NA 47 1526 1333 10 4 2 39 5 11 12 47 47 1
PT 204 12461 7823 46 4 3 165 8 10 120 204 204 1
SC 23 1237 1047 13 2 0 23 5 1 12 23 23 1
SP 417 19211 10285 54 4 3 356 9 17 205 416 416 2
TC 7 300 286 12 0 2 5 2 2 3 7 7 1
<NA> 2 0 0 0 0 0 0 0 0 0 2 2 1
Set Card number Name Rarity Print Quantity Release Series Set type Cover card Page URL Modification date _merge
count 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000 17.000000
mean 227.764706 8976.411765 5099.470588 32.352941 3.117647 1.764706 186.647059 8.176471 10.705882 101.058824 226.882353 226.882353 1.411765
std 254.359620 9337.505656 5032.673111 28.713980 3.461978 1.393261 205.059120 8.225230 8.716111 106.359338 253.258238 253.258238 0.507300
min 2.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 2.000000 2.000000 1.000000
25% 7.000000 300.000000 286.000000 9.000000 0.000000 0.000000 5.000000 2.000000 2.000000 3.000000 7.000000 7.000000 1.000000
50% 47.000000 1527.000000 1493.000000 13.000000 4.000000 2.000000 39.000000 5.000000 10.000000 19.000000 47.000000 47.000000 1.000000
75% 447.000000 19211.000000 10388.000000 55.000000 4.000000 3.000000 375.000000 12.000000 18.000000 218.000000 446.000000 446.000000 2.000000
max 714.000000 20372.000000 11213.000000 94.000000 14.000000 3.000000 536.000000 28.000000 28.000000 247.000000 709.000000 709.000000 2.000000

Cover card¶

Total number of cover cards: 671
Set Card number Name Rarity Print Quantity Region Release Series Set type Page URL Modification date _merge
Cover card
A-to-Z-Dragon Buster Cannon 1 352 54 4 2 2 8 4 0 1 1 1 1
Accel Synchro Stardust Dragon 1 100 50 3 2 0 2 2 0 1 1 1 1
Accesscode Talker 1 766 101 16 2 0 8 3 1 1 1 1 1
Adamancipator Risen - Dragite 1 135 45 3 2 0 3 3 0 1 1 1 1
Adreus, Keeper of Armageddon 1 84 42 4 0 0 2 2 0 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Yamiterasu the Divine Ruler 1 132 66 6 0 0 2 2 1 1 1 1 1
Yoko, the Graceful Mayakashi 2 450 60 4 2 0 8 3 0 1 2 2 1
Yubel - The Ultimate Nightmare 2 560 100 10 0 0 6 5 1 2 2 2 1
Z-Metal Tank 1 55 55 7 0 0 1 1 1 1 1 1 1
Zerrziel, Ruler of the Evil Eyed 1 90 45 3 2 0 2 2 0 1 1 1 1

671 rows × 13 columns

Series¶

Total number of series: 45
Set Card number Name Rarity Print Quantity Region Release Set type Cover card Page URL Modification date _merge
Series
+1 Bonus Pack 7 249 137 3 0 0 2 12 1 0 7 7 1
Animation Chronicle 2 200 100 7 2 0 2 4 1 2 2 2 1
Astral Pack 7 1110 184 4 4 0 6 16 1 0 7 7 1
Attribute Duelist Pack 4 429 199 6 3 0 3 9 1 4 4 4 1
Battle Pack (Rush Duel) 8 80 80 3 3 0 1 8 1 0 8 8 1
Booster (series) 4 181 176 7 2 0 1 4 1 2 4 4 1
Booster pack 1 50 50 3 0 0 1 1 1 0 1 1 1
Champion Pack 8 640 161 4 2 0 4 8 1 0 8 8 1
Classic Pack 3 570 424 9 2 0 1 3 1 2 3 3 1
Collectors Pack 8 794 374 12 3 0 3 16 1 8 8 8 1
Core Booster 88 49929 7471 41 2 0 13 296 1 80 88 88 1
Deck Build Pack 3 360 134 5 2 0 3 8 1 3 3 3 1
Deck Mod Pack 12 1447 756 8 0 0 2 23 1 12 12 12 1
Duelist Pack 21 3739 634 7 3 0 8 49 1 19 21 21 1
Entry Pack (series) 10 163 160 3 2 0 1 10 1 0 10 10 1
Expansion Pack 4 280 280 6 0 0 1 4 1 0 4 4 1
Gold Series (series) 8 2595 446 9 2 0 9 18 1 0 8 8 1
Hidden Arsenal (series) 7 2470 400 2 2 0 7 16 1 7 7 7 1
Hobby League 1 83 43 3 0 0 5 0 1 0 1 1 1
Jump Victory Carnival 1 1 1 1 0 0 1 1 1 0 1 1 1
Legend Duelist (series) 6 780 343 10 2 0 3 14 1 6 6 6 1
Legendary Collection (series) 2 57 19 1 2 0 3 4 1 0 2 2 1
Master Guide promotional cards (series) 4 8 8 1 0 0 1 4 1 0 4 4 1
Mattel Action Figure promotional cards 3 17 16 1 0 0 1 3 1 0 3 3 1
McDonald's Promotional Cards 2 35 35 4 3 0 2 2 1 0 2 2 1
Monster Figure Collection promotional cards 3 15 15 1 0 0 1 3 1 0 3 3 1
OTS Tournament Pack 2 324 54 4 0 0 6 3 1 0 2 2 1
Perfect Rulebook promotional cards 3 3 3 2 0 0 1 3 1 0 3 3 1
Pharaoh Tour promotional cards 3 20 5 2 0 0 4 3 1 0 3 3 1
Premium Pack 25 452 368 8 3 0 2 25 1 12 25 25 1
Shonen Jump promotional cards 78 85 81 2 0 0 2 44 1 0 78 78 1
Sneak Peek Participation Cards 57 302 61 4 0 0 8 69 1 0 57 57 1
Star Pack 3 900 149 4 0 0 6 6 1 3 3 3 1
Structure Deck R 3 248 122 4 2 2 2 6 1 3 3 3 1
The Valuable Book promotional cards 18 38 38 2 0 0 2 19 1 0 18 18 1
V Jump August 1999 Special Present 1 0 6 1 0 0 1 1 1 0 1 1 1
V Jump Edition (series) 4 16 16 3 0 0 1 4 1 0 4 4 1
V Jump promotional cards 78 94 98 6 0 0 1 74 1 0 78 78 1
Value Box 9 11 11 3 0 0 1 7 1 0 9 9 1
Yu-Gi-Oh! 5D's manga promotional cards 9 19 9 2 0 0 3 18 1 0 9 9 1
Yu-Gi-Oh! Day promotional cards 7 7 1 1 0 0 2 7 1 0 7 7 1
Yu-Gi-Oh! GX manga promotional cards 9 19 9 3 0 0 3 17 1 0 9 9 1
Yu-Gi-Oh! R promotional cards 4 8 4 2 0 0 2 8 1 0 4 4 1
Yu-Gi-Oh! World Championship prize cards 13 35 30 5 0 0 3 13 1 0 13 13 1
Yu-Gi-Oh! ZEXAL manga promotional cards 8 25 8 1 0 0 4 25 1 0 8 8 1

Set type¶

Total number of set types: 37
Set Card number Name Rarity Print Quantity Region Release Series Cover card Page URL Modification date _merge
Set type
Beta set 1 535 106 1 0 2 5 1 0 0 1 1 1
Binder 2 6 6 2 2 0 1 2 0 0 2 2 1
Book promotional card 4 5 5 3 0 0 2 4 1 0 4 4 1
Book promotional cards 26 52 52 4 0 0 2 27 2 0 26 26 1
Booster pack 467 114012 11764 114 15 0 14 809 23 223 467 467 1
Boss Duel Deck 1 8 8 1 0 0 1 1 0 0 1 1 1
Bundle 9 11 11 3 0 0 1 7 1 0 9 9 1
Collectible tin 53 5901 1005 11 4 0 8 66 0 35 53 53 1
Collector's Set 11 6226 1102 7 2 3 7 14 0 6 11 11 1
Core Booster 1 160 80 6 0 0 2 2 0 1 1 1 1
Deluxe Edition 4 114 19 2 0 0 6 8 0 4 4 4 1
Demo Deck 4 380 64 1 0 0 7 8 0 1 4 4 1
Duel Disk 2 16 9 2 2 0 2 4 0 0 2 2 1
Duel Disk promotional cards 5 13 12 4 0 0 2 5 0 0 5 5 1
Duel Terminal 34 1847 706 6 2 0 2 31 0 10 34 34 1
Duelist League participation cards 10 60 16 3 0 0 9 9 0 0 10 10 1
Duelist Set 5 312 154 5 0 2 2 5 0 5 5 5 1
Enhancement Pack 2 20 20 1 0 0 1 1 0 0 2 2 1
Hobby League participation cards 40 83 43 3 0 0 5 38 0 0 40 40 1
Magazine promotional card 167 191 173 9 0 0 3 127 3 7 167 167 1
Magazine promotional cards 4 4 4 2 0 0 2 2 0 0 4 4 1
Main Deck 2 44 44 2 0 0 1 2 0 1 2 2 1
Manga promotional card 33 74 32 3 0 0 4 69 4 0 33 33 1
Participation card 60 485 119 8 0 0 9 71 2 0 60 60 1
Preconstructed Deck 6 401 223 10 3 0 2 8 0 4 6 6 1
Prize card 16 46 41 5 0 0 3 16 1 0 16 16 1
Prize cards 1 68 20 1 0 0 5 1 0 0 1 1 1
Promotional card 140 315 206 22 3 0 9 141 6 21 140 140 1
Promotional cards 25 200 62 10 2 0 10 34 1 1 25 25 1
Special Edition 90 1189 289 12 5 0 10 109 0 1 90 90 1
Starter Deck 38 6777 606 10 2 3 14 59 0 26 38 38 1
Structure Deck 64 9454 1206 8 2 3 10 117 1 45 64 64 1
Tournament prize card 1 2 2 1 0 0 1 1 0 0 1 1 1
Tournament promotional card 2 5 2 2 0 0 2 2 0 0 2 2 1
Vendor Edition 6 210 210 2 0 0 1 6 0 0 6 6 1
Video game promotional card 9 79 39 5 0 0 8 15 0 0 9 9 1
Video games promotional card 23 325 73 7 2 0 9 43 0 0 23 23 1

Release¶

Total number of release dates: 1573
Set Card number Name Rarity Print Quantity Region Series Set type Cover card Page URL Modification date _merge
Release
1999-03-01 1 0 40 2 2 0 1 1 1 0 1 1 1
1999-03-18 1 0 1 1 0 0 1 0 1 0 1 1 1
1999-04-29 1 0 1 1 0 0 1 0 1 0 1 1 1
1999-05-05 1 0 1 1 0 0 1 0 1 0 1 1 1
1999-05-25 1 0 40 2 0 0 1 1 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
2023-01-26 1 1 1 1 0 0 1 0 1 0 1 1 1
2023-02-25 1 190 44 5 2 0 1 1 1 0 1 1 1
2023-03-01 3 2 3 3 0 0 1 0 1 0 3 3 1
2023-05-01 3 3 3 1 0 0 1 0 1 0 3 3 1
NaT 119 3971 1085 25 4 2 13 9 13 14 111 111 3

1574 rows × 13 columns

By year¶

Set Card number Name Rarity Print Quantity Region Series Set type Cover card Page URL _merge
Release
1999 18 0 353 28 10 2 15 8 15 1 18 15
2000 12 274 324 21 9 2 10 8 11 5 12 10
2001 12 305 307 30 4 4 12 4 11 6 12 12
2002 22 1369 1197 81 10 2 21 9 20 14 22 19
2003 51 2669 2263 125 12 0 52 12 41 29 51 38
2004 93 6502 4687 198 6 0 108 27 74 45 93 59
2005 75 7826 4043 165 27 18 127 28 64 37 75 49
2006 101 5241 3045 186 22 20 125 39 92 42 101 67
2007 126 5744 3344 283 16 18 192 53 115 54 126 94
2008 124 5979 3248 276 21 12 194 51 113 50 124 95
2009 117 5104 2973 284 6 14 172 40 111 54 117 93
2010 138 6093 3322 320 8 16 204 58 124 53 138 103
2011 144 6922 3952 326 16 18 214 55 133 53 144 105
2012 141 10271 5425 357 17 20 218 57 128 53 141 111
2013 146 8913 4469 344 18 24 222 68 129 69 146 108
2014 141 12625 5705 388 38 20 225 68 126 60 141 107
2015 136 10432 4828 358 33 12 221 69 125 57 136 103
2016 137 10356 4755 337 39 10 210 62 124 59 137 97
2017 67 8404 3324 199 27 6 140 29 64 35 67 54
2018 46 5413 2129 141 26 0 103 20 41 28 46 41
2019 50 6264 2670 162 29 0 101 17 45 25 50 43
2020 38 6435 2143 151 34 0 85 18 36 27 38 36
2021 65 6812 2733 241 46 6 91 38 53 36 65 49
2022 73 8953 3673 250 66 3 96 43 61 42 73 56
2023 15 798 353 42 7 0 15 7 9 4 15 9

By month¶

By day¶

By region¶

Set Card number Name Rarity Print Quantity Series Set type Cover card Page URL Modification date _merge
Region Release
AE 2001-06-04 1 0 2 1 0 0 0 0 0 1 1 1
2002-08-08 2 100 87 3 0 0 0 1 2 2 2 1
2002-10-24 1 144 144 5 0 0 1 1 1 1 1 1
2003-04-17 1 3 3 1 0 0 0 1 0 1 1 1
2003-06-26 1 105 105 5 0 0 1 1 1 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
TC 2014-01-29 1 40 40 4 0 2 0 1 1 1 1 1
2014-05-01 1 20 20 4 0 0 1 1 0 1 1 1
2015-03-01 2 40 26 1 0 0 0 0 0 2 2 1
2015-08-29 1 100 100 6 0 0 1 1 1 1 1 1
2015-12-05 1 100 100 6 0 0 1 1 1 1 1 1

3173 rows × 12 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Region
AE 0 0 1 3 4 3 3 5 2 1 4 1 1 1 1 1 1 0 0 0 0 0 0 0 0
AU 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
DE 0 0 0 0 8 21 22 17 31 27 23 28 31 30 28 30 27 28 20 15 13 10 8 7 1
EN 0 0 2 2 3 16 29 48 50 45 33 45 47 49 42 43 34 35 20 15 13 10 12 11 2
EU 0 0 0 2 2 4 0 0 0 2 0 2 0 0 0 2 2 1 0 0 0 0 0 0 0
FC 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
FR 0 0 0 0 5 20 22 17 31 27 23 27 28 30 29 28 27 28 19 15 13 10 8 7 1
IT 0 0 0 0 5 20 21 17 31 27 23 27 29 30 28 28 27 28 20 15 13 10 8 7 1
JA 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0
JP 18 12 9 11 11 20 24 26 32 40 40 49 46 44 49 43 43 52 14 16 20 14 25 26 10
KR 0 0 0 0 2 8 7 13 20 24 21 21 30 29 29 23 22 21 17 10 12 10 23 26 1
NA 0 0 0 5 16 6 0 2 2 1 2 1 1 0 0 2 3 0 2 0 0 0 0 0 0
PT 0 0 0 0 0 10 6 0 0 0 0 0 0 1 24 24 25 26 18 14 13 9 8 7 1
SC 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 7 10 2
SP 0 0 0 0 4 20 20 10 24 22 21 27 27 30 28 28 27 28 19 14 13 10 9 7 1
TC 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 4 0 0 0 0 0 0 0 0

By series¶

Set Card number Name Rarity Print Quantity Region Set type Cover card Page URL Modification date _merge
Series Release
+1 Bonus Pack 2020-10-31 1 19 19 3 0 0 1 1 0 1 1 1
2021-02-04 1 20 20 3 0 0 1 1 0 1 1 1
2021-04-17 1 19 19 3 0 0 1 1 0 1 1 1
2021-07-17 1 19 19 3 0 0 1 1 0 1 1 1
2021-07-21 1 19 19 3 0 0 1 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Yu-Gi-Oh! ZEXAL manga promotional cards 2015-09-01 1 1 1 1 0 0 1 1 0 1 1 1
2015-10-03 1 1 1 1 0 0 1 1 0 1 1 1
2015-12-18 1 1 1 1 0 0 1 1 0 1 1 1
2016-03-01 1 1 1 1 0 0 1 1 0 1 1 1
2016-09-06 1 1 1 1 0 0 1 1 0 1 1 1

888 rows × 12 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Series
+1 Bonus Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 6 4 1
Animation Chronicle 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 0
Astral Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 8 3 0 0 0 0 0 0 0 0
Attribute Duelist Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 3 4 0
Battle Pack (Rush Duel) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 4 1
Booster (series) 0 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Booster pack 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Champion Pack 0 0 0 0 0 0 0 1 3 3 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Classic Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1
Collectors Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 2 2 2 2 2 2 0 0 0
Core Booster 6 0 2 6 11 22 17 17 25 13 14 15 14 16 18 16 17 16 12 10 8 6 8 8 1
Deck Build Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 6 0
Deck Mod Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 9 8 2
Duelist Pack 0 0 0 0 0 0 2 9 9 10 4 6 7 3 3 1 3 5 1 0 0 0 0 0 0
Entry Pack (series) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 4 1
Expansion Pack 0 0 0 0 0 0 0 0 0 3 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0
Gold Series (series) 0 0 0 0 0 0 0 0 0 2 0 2 3 2 0 5 2 2 0 0 0 0 0 0 0
Hidden Arsenal (series) 0 0 0 0 0 0 0 0 0 0 1 3 6 3 3 0 0 0 0 0 0 0 0 0 0
Jump Victory Carnival 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0
Legend Duelist (series) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 4 4 1 1 1 0
Legendary Collection (series) 0 0 0 0 0 0 0 0 0 0 0 2 2 0 0 0 0 0 0 0 0 0 0 0 0
Master Guide promotional cards (series) 0 0 0 0 0 1 0 0 0 1 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0
Mattel Action Figure promotional cards 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
McDonald's Promotional Cards 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monster Figure Collection promotional cards 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0
OTS Tournament Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0
Perfect Rulebook promotional cards 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0
Pharaoh Tour promotional cards 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Premium Pack 0 3 1 0 0 3 1 1 1 2 2 2 1 2 2 2 2 0 0 0 0 0 0 0 0
Shonen Jump promotional cards 0 0 0 0 0 0 2 3 4 3 2 7 2 4 4 6 4 6 1 0 0 0 0 0 0
Sneak Peek Participation Cards 0 0 0 0 0 0 4 4 9 8 3 4 4 5 4 4 4 5 5 3 2 1 0 0 0
Star Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 1 2 0 0 0 0 0 0 0 0
Structure Deck R 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 4 1 0 0 0 0 0 0
The Valuable Book promotional cards 1 1 0 2 1 1 1 1 1 1 1 1 1 1 2 1 1 0 1 0 0 0 0 0 0
V Jump August 1999 Special Present 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V Jump Edition (series) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 1 0 0 0 0
V Jump promotional cards 0 0 0 0 0 0 0 0 0 5 7 7 7 8 10 8 11 13 2 0 0 0 0 0 0
Value Box 0 0 0 0 0 0 0 0 0 0 0 0 1 2 4 1 1 0 0 0 0 0 0 0 0
Yu-Gi-Oh! 5D's manga promotional cards 0 0 0 0 0 0 0 0 0 0 0 2 2 3 4 3 3 1 0 0 0 0 0 0 0
Yu-Gi-Oh! Day promotional cards 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 2 1 0 0 0 0 0 0
Yu-Gi-Oh! GX manga promotional cards 0 0 0 0 0 0 0 1 2 3 3 4 3 2 0 0 0 0 0 0 0 0 0 0 0
Yu-Gi-Oh! R promotional cards 0 0 0 0 0 0 1 1 1 1 1 3 0 0 0 0 0 0 0 0 0 0 0 0 0
Yu-Gi-Oh! World Championship prize cards 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
Yu-Gi-Oh! ZEXAL manga promotional cards 0 0 0 0 0 0 0 0 0 0 0 0 0 4 6 6 7 2 0 0 0 0 0 0 0

By set type¶

Set Card number Name Rarity Print Quantity Region Series Cover card Page URL Modification date _merge
Set type Release
Beta set 2017-10-04 1 535 106 1 0 2 5 0 0 1 1 1
Binder 2012-09-21 1 3 3 1 2 0 1 0 0 1 1 1
2015-04-29 1 3 3 1 0 0 1 0 0 1 1 1
Book promotional card 2004-12-18 1 2 2 1 0 0 1 0 0 1 1 1
2014-04-04 1 1 1 1 0 0 1 1 0 1 1 1
... ... ... ... ... ... ... ... ... ... ... ... ... ...
Video games promotional card 2011-04-28 1 7 7 1 0 0 1 0 0 1 1 1
2011-05-10 1 3 3 1 0 0 1 0 0 1 1 1
2013-12-05 1 3 3 1 0 0 1 0 0 1 1 1
2014-06-26 1 15 3 2 0 0 5 0 0 1 1 1
2016-07-16 1 1 1 1 0 0 1 0 0 1 1 1

1865 rows × 12 columns

Release 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023
Set type
Beta set 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0
Binder 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0
Book promotional card 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0
Book promotional cards 1 2 0 2 1 2 1 1 1 2 1 1 2 1 3 2 2 1 1 0 0 0 0 0 0
Booster pack 6 7 4 10 15 40 34 36 44 43 35 48 53 54 59 65 56 52 38 28 31 31 52 53 8
Boss Duel Deck 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0
Bundle 0 0 0 0 0 0 0 0 0 0 0 0 1 2 4 1 1 0 0 0 0 0 0 0 0
Collectible tin 0 0 0 1 2 2 2 3 3 7 10 6 5 4 7 2 2 2 2 1 2 1 1 1 0
Collector's Set 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 0 0 3 2 1 4 0
Core Booster 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Deluxe Edition 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 6 0 0 0 0 0 0 0 0 0
Demo Deck 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 2 2 0 3 0 0 0 0 0
Duel Disk 0 0 0 0 0 0 0 1 1 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0
Duel Disk promotional cards 0 0 0 0 0 0 0 1 1 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Duel Terminal 0 0 0 0 0 0 0 0 0 6 4 7 6 9 2 0 0 0 0 0 0 0 0 0 0
Duelist League participation cards 0 0 0 0 4 4 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Duelist Set 0 0 0 0 0 0 0 0 0 0 0 0 0 3 5 1 0 0 0 0 0 0 0 0 0
Enhancement Pack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0
Hobby League participation cards 0 0 0 0 0 2 1 13 12 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Magazine promotional card 1 0 0 0 0 0 3 3 4 10 10 17 10 13 14 14 15 20 3 0 0 0 0 0 0
Magazine promotional cards 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Main Deck 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0
Manga promotional card 0 0 0 1 0 0 1 4 3 4 4 9 5 9 10 9 10 3 0 0 0 0 0 0 0
Participation card 1 0 0 0 0 0 4 4 9 8 4 5 4 5 4 4 4 5 5 3 2 1 0 0 0
Preconstructed Deck 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 0 0 4 0
Prize card 0 0 2 0 0 1 1 1 1 1 1 1 2 1 1 1 1 1 0 0 0 0 0 0 0
Prize cards 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0
Promotional card 2 0 2 1 0 1 1 8 8 5 7 14 19 8 5 5 7 17 5 3 6 2 9 11 7
Promotional cards 2 0 1 1 5 7 2 1 0 0 1 4 3 1 3 2 1 0 0 0 1 0 0 0 0
Special Edition 0 0 0 0 2 3 3 7 12 11 13 8 8 12 2 3 7 8 7 4 2 1 0 0 0
Starter Deck 1 1 0 4 13 18 2 0 3 2 5 4 3 4 8 5 7 4 0 0 0 0 2 0 0
Structure Deck 0 0 2 1 3 0 8 10 8 6 7 6 9 9 8 11 13 17 4 0 0 0 0 0 0
Tournament prize card 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Tournament promotional card 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Vendor Edition 0 0 0 0 0 1 2 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Video game promotional card 1 2 0 0 0 0 0 0 5 0 3 4 2 0 0 0 0 0 0 0 0 0 0 0 0
Video games promotional card 0 0 0 1 3 8 7 4 8 4 3 0 4 0 1 1 0 1 0 0 0 0 0 0 0

Debug¶

This section is used for debugging the extraction of data from MediaWiki query responses

Has nan name/number¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
22517 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> PT 2016-10-07 <NA> Collector's Set NaN https://yugipedia.com/wiki/Legendary_Decks_II 2022-01-18 14:06:23 both
22562 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> PT 2016-10-07 <NA> Collector's Set NaN https://yugipedia.com/wiki/Legendary_Decks_II 2022-01-18 14:06:23 both
22607 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> PT 2016-10-07 <NA> Collector's Set NaN https://yugipedia.com/wiki/Legendary_Decks_II 2022-01-18 14:06:23 both
22655 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> DE 2016-10-06 <NA> Collector's Set NaN https://yugipedia.com/wiki/Legendary_Decks_II 2022-01-18 14:06:23 both
22700 Legendary Decks II <NA> <NA> (Common,) <NA> <NA> DE 2016-10-06 <NA> Collector's Set NaN https://yugipedia.com/wiki/Legendary_Decks_II 2022-01-18 14:06:23 both
... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
145181 EX Starter Box <NA> De-Spell (Common,) Reprint 2 JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) https://yugipedia.com/wiki/EX_Starter_Box 2022-05-01 06:51:59 both
145182 EX Starter Box <NA> Castle Walls (Common,) Reprint 1 JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) https://yugipedia.com/wiki/EX_Starter_Box 2022-05-01 06:51:59 both
145183 EX Starter Box <NA> Ultimate Offering (Common,) Reprint 1 JP 1999-12-16 <NA> Starter Deck (Blue-Eyes White Dragon,) https://yugipedia.com/wiki/EX_Starter_Box 2022-05-01 06:51:59 both
156162 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Academia_Disk 2022-12-28 20:46:20 right_only
156163 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Structure_Deck:_Mar... 2014-07-03 18:52:14 right_only

732 rows × 14 columns

Has nan rarity¶

array(['Dark Beginning 2', 'Advanced Event Pack 2014 Vol.1',
       'Dark Revelation Volume 1', 'Dark Revelation Volume 2',
       'Advanced Tournament Pack 2016 Vol.1',
       'Advanced Tournament Pack 2013 Vol.4', 'Dark Beginning 1',
       'The Valuable Book character cards',
       'Advanced Tournament Pack 2013 Vol.3', 'V Jump April 2013 Tokens',
       'Advanced Event Pack 2013 Vol.2', 'Classic Pack 03',
       'Deck Build Pack: Tactical Masters', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

Has nan release¶

array(['Invasion: Vengeance Sneak Peek Participation Card',
       'Shonen Jump Vol. 6, Issue 5 promotional card',
       'Ancient Prophecy Sneak Peek Participation Card',
       'Crossed Souls Sneak Peek Participation Card',
       'Duelist League Demo 2010',
       'Shonen Jump December 2010 subscription bonus',
       'Tournament Pack 2008 Vol.2',
       'Yu-Gi-Oh! Power of Chaos: Kaiba the Revenge promotional cards',
       'Hobby League 6 participation card A',
       'Legacy of the Valiant Sneak Peek Participation Card',
       'Secrets of Eternity Sneak Peek Participation Card',
       'Shonen Jump Scholastic Edition Vol. 9, Issue 1 promotional card',
       'The New Challengers Sneak Peek Participation Card',
       "Yu-Gi-Oh! 5D's Wheelie Breakers promotional cards",
       'Astral Pack One',
       "Structure Deck: Dinosaur's Rage Special Edition",
       'Structure Deck: Marik',
       "Yu-Gi-Oh! 5D's World Championship 2011: Over the Nexus promotional cards",
       'Hobby League participation cards',
       'Shonen Jump Vol. 10, Issue 4 promotional card', 'Spell Ruler',
       'The Sanctuary in the Sky', 'Yu-Gi-Oh! R promotional cards',
       'Shonen Jump Vol. 3, Issue 9 promotional card',
       'Shonen Jump Vol. 5, Issue 1 promotional card',
       'Shonen Jump Vol. 7, Issue 9 promotional card',
       'The Lost Millennium: Special Edition',
       'Yu-Gi-Oh! GX Volume 4 promotional card',
       'Yu-Gi-Oh! Worldwide Edition: Stairway to the Destined Duel promotional cards',
       'Hobby League 7 participation card A',
       'Shonen Jump May 2006 subscription bonus',
       'Shonen Jump Vol. 9, Issue 6 promotional card', 'Premium Pack 2',
       'Raging Battle Sneak Peek Participation Card', 'Ancient Sanctuary',
       'National Championship 2011',
       'Shonen Jump May 2008 subscription bonus',
       'Tournament Pack 2009 Vol.3', 'Tournament Pack 2009 Vol.4',
       'Astral Pack Two',
       'Dimension of Chaos Sneak Peek Participation Card',
       'Shadow Specters Sneak Peek Participation Card',
       'Shadow of Infinity: Special Edition',
       'Shonen Jump June/July 2011 subscription bonus',
       'Shonen Jump Vol. 7, Issue 3 promotional card',
       'Yu-Gi-Oh! GX manga promotional cards',
       'Hobby League 6 participation card B', 'Millennium Pack',
       'Structure Deck: Machine Re-Volt Special Edition',
       'Shonen Jump August 2008 subscription bonus',
       'Shonen Jump Vol. 3, Issue 11 promotional card',
       'The Valuable Book promotional cards',
       "Yu-Gi-Oh! 5D's Volume 1 promotional card",
       "Yu-Gi-Oh! 5D's manga promotional cards", 'Invader of Darkness',
       'Premium Pack', "Structure Deck: Dinosaur's Rage Special Set",
       'Shonen Jump Vol. 5, Issue 6 promotional card',
       'Yu-Gi-Oh! The Official Magazine promotional cards',
       'Sneak Peek Participation Cards',
       'Hobby League 7 participation card B',
       'Shonen Jump Vol. 9, Issue 8 promotional card',
       'National Championship 2012',
       'Shonen Jump Vol. 6, Issue 9 promotional card',
       'Hobby League 6 participation card C',
       'Shonen Jump Vol. 4, Issue 2 promotional card',
       'Shonen Jump Vol. 6, Issue 1 promotional card', 'Duel Disk',
       'Shonen Jump May 2010 subscription bonus',
       'The Valuable Book character cards', 'Tournament Pack 2008 Vol.1',
       'Banzai! promotional cards',
       'Shonen Jump Vol. 7, Issue 11 promotional card',
       'Ultimate Edition',
       'Shonen Jump Vol. 9, Issue 10 promotional card',
       'Hobby League 7 participation card C',
       'National Championship 2013',
       'Shonen Jump Championship Series Prize Cards',
       'Shonen Jump Vol. 9, Issue 1 promotional card', 'Curse of Anubis',
       'Hobby League 6 participation card D', 'Academy Duel Disk',
       'Gold Series', 'Hobby League 7 participation card D',
       'Shonen Jump Vol. 10, Issue 1 promotional card', 'Magic Ruler',
       'Shonen Jump Vol. 4, Issue 11 promotional card',
       'Shonen Jump Vol. 7, Issue 6 promotional card',
       'Hobby League 6 participation card E',
       'Shonen Jump Vol. 10, Issue 3 promotional card',
       'Shonen Jump Vol. 3, Issue 6 promotional card',
       'Shonen Jump Vol. 4, Issue 12 promotional card',
       'Yu-Gi-Oh! Championship Series Prize Cards',
       'Hobby League 6 participation card F',
       'Shonen Jump Vol. 9, Issue 4 promotional card',
       '2013 Collectible Tins', '20th Anniversary Duel Set',
       'Booster Pack Tin Series Promos',
       'Chinese Weekly Shōnen Jump lottery prize cards',
       'Collectible Tins 2005', 'Collectible Tins 2006',
       'Collectible Tins 2007', 'Collectible Tins 2008',
       'Collectible Tins 2008 Wave 2', 'Collectible Tins 2009',
       'Collectible Tins 2010', 'Collectible Tins 2011',
       'Collectible Tins 2012',
       'Continuous Token Gifts Promotional Cards', 'Demo Pack',
       'Duelist League 18 participation cards',
       'Duelist League Series 1 participation cards',
       'Duelist League Series 2 participation cards',
       'Duelist Pack: Yugi', 'Exclusive Pack', 'Ghosts From the Past',
       'Judge promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)

Merge failed¶

Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge
156162 Academia Disk <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Academia_Disk 2022-12-28 20:46:20 right_only
156163 Structure Deck: Marik (disambiguation) <NA> <NA> NaN <NA> <NA> <NA> NaT <NA> <NA> NaN https://yugipedia.com/wiki/Structure_Deck:_Mar... 2014-07-03 18:52:14 right_only 
8
array(['Abyss Rising', 'Ancient Prophecy', 'Battle Pack: Epic Dawn', ...,
       'Jump Festa 2005 promotional cards', 'Academia Disk',
       'Structure Deck: Marik (disambiguation)'], dtype=object)
Set Card number Name Rarity Print Quantity Region Release Series Set type Cover card Page URL Modification date _merge

Epilogue¶

Execution completed 31/01/2023 23:01 UTC

HTML export¶

Notebook saved to disk